package com.hnchances.mapper;

import com.hnchances.entity.Student;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author XW.Fan
 * @since 2022-08-08
 */
@Mapper
public interface StudentMapper extends BaseMapper<Student> {
    @Select("select * from student where idcard=#{idcard}")
    public Student findStudentByIdCard(String idcard);

    //通过学生姓名查询id
    @Select("select * from student where name=#{name}")
    public Integer findByNameId(String name);
}
